if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].sp_NhomKhachHang_GetAllOrderByName') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].sp_NhomKhachHang_GetAllOrderByName
GO

CREATE PROCEDURE sp_NhomKhachHang_GetAllOrderByName
AS
	SELECT	ID,Ten,Chiet_khau,Ghi_chu from NhomKhachHang where ma_loai_khach_hang = 0 order by ten